SUPPORT / SAMPLES & SAS NOTES
Problem Note 56579: CSV files that are generated from online aggregation and optimization are not purged
 |  |  |  |
In the SAS® Revenue Optimization Suite, CSV files that are generated during online optimization or online aggregation are not purged. The CSV files created during online optimization and online aggregation are written to table specific folders in the data mart, <di_dm>/<table>. The CSV files created during batch optimization and batch aggregation are written to captain specific folders in those table directories, <di_dm>/<table>/<captain_name>. During the %TKMI_JOB_RO etl_end_service task, the batch CSV files in the captain folders are deleted. The %TKM_JOB_RO etl_end_service task does not delete the CSV files located in <di_dm>/<table>.
The workaround for this issue is to delete the CSV files located in <di_dm>/<table>.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Promotion Optimization | Linux for x64 | 5.2 | 5.4 | 9.3 TS1M1 | 9.4 TS1M4 |
| Microsoft® Windows® for x64 | 5.2 | 5.4 | 9.3 TS1M1 | 9.4 TS1M4 | ||
| SAS System | SAS Markdown Optimization | Linux for x64 | 5.2 | 5.4 | 9.3 TS1M1 | 9.4 TS1M4 |
| Microsoft® Windows® for x64 | 5.2 | 5.4 | 9.3 TS1M1 | 9.4 TS1M4 | ||
| SAS System | SAS Regular Price Optimization | Microsoft® Windows® for x64 | 5.2 | 5.4 | 9.3 TS1M1 | 9.4 TS1M4 |
| Linux for x64 | 5.2 | 5.4 | 9.3 TS1M1 | 9.4 TS1M4 | ||